How to: Use predefined date formats.
Solution:
Select the cells containing the dates to format. Select 'Cells...' from the 'Format' menu to display the 'Format Cells' dialog box. Click the 'Number' tab, select the 'Date' category, and select the desired format from the 'Type' list box.
1) Select the cells containing the dates to format.
2) Select the 'Format' menu and select 'Cells...'. (The Format Cells dialog box appears.)
3) Click the 'Number' tab.
4) Select 'Date' from the 'Category' list box. (Excel displays the Type list box to the right of the Category list box.)
5) Select the desired predefined format from the 'Type' list box.
6) Click 'OK'.
